Skip Headers

Oracle® Database Utilities 10g Release 2 (10.2) Part Number B14215-01 |
Home | Book List | Contents | Master Index | Feedback

Previous
| View PDF

# Index

A B C D E F G H I J K L M N O P Q R S T U V W X Z

## A

  access privileges
    Export and Import, 19.2.3
  ADD_FILE parameter
    Data Pump Export utility
      interactive-command mode, 2.6.1
  Advanced Queuing
    exporting advanced queue tables, 19.27.4.10
    importing advanced queue tables, 19.28.5.10
  aliases
    directory
      exporting, 19.27.4.5
      importing, 19.28.5.5
  analyzer statistics, 19.28.3
  analyzing redo log files, 17
  ANYDATA type
    effect on table-mode Import, 19.8
    using SQL strings to load, 9.12.6
  APPEND parameter
    SQL*Loader utility, 8.14.2
  append to table
    SQL*Loader, 8.13.2.2.1
  archiving
    disabling
      effect on direct path loads, 11.5.4.1
  arrays
    committing after insert, 19.10.2
  ASMCMD
    about, 20.1
    command reference, 20.4
    running, 20.3
  ASMCMD utility, 20
  atomic null, 10.1.5.2
  ATTACH parameter
    Data Pump Export utility, 2.4.1
    Data Pump Import utility, 3.4.1
  attaching to an existing job
    Data Pump Export utility, 2.4.1
  attributes
    null, 10.1.5.1
  attribute-value constructors
    overriding, 10.1.6
  Automatic Storage Management
    command-line utility, 20
  Automatic Storage Management (ASM)
    Data Pump and, 1.7.2.1

## B

  backslash escape character, 8.3.3.2
  backups
    restoring dropped snapshots
      Import, 19.18.2.1
  Backus-Naur Form syntax
    See syntax diagrams
  bad files
    specifying for SQL*Loader, 8.8
  BAD parameter
    SQL*Loader command line, 7.2.1
  BADFILE parameter
    SQL*Loader utility, 8.8
  BEGINDATA parameter
    SQL*Loader control file, 8.6
  BFILE columns
    exporting, 19.27.4.6
    importing, 19.28.5.5
  BFILE datatype, 10.5
  big-endian data
    external tables, 13.2.7
  bind arrays
    determining size of for SQL*Loader, 8.16.4
    minimizing SQL*Loader memory requirements, 8.16.5
    minimum requirements, 8.16.1
    size with multiple SQL*Loader INTO TABLE statements, 8.16.6
    specifying maximum size, 7.2.2
    specifying number of rows, 7.2.22
    SQL*Loader performance implications, 8.16.2
  BINDSIZE parameter
    SQL*Loader command line, 7.2.2, 8.16.3
  blanks
    loading fields consisting of blanks, 9.9
    SQL*Loader BLANKS parameter for field comparison, 9.5.1
    trailing, 9.4.5.6
    trimming, 9.10
      external tables, 13.3.2
    whitespace, 9.10
  BLANKS parameter
    SQL*Loader utility, 9.5.1
  BNF
    See syntax diagrams
  bound fillers, 9.3.1
  buffer cache size
    and Data Pump operations involving Streams, 4.3.1
  BUFFER parameter
    Export utility, 19.9.1
    Import utility, 19.10.1
  buffers
    calculating for export, 19.9.1
    space required by
      VARCHAR data in SQL*Loader, 9.4.1.9
    specifying with SQL*Loader BINDSIZE parameter, 8.16.4
  byte order, 9.8
    big-endian, 9.8
    little-endian, 9.8
    specifying in SQL*Loader control file, 9.8.1
  byte order marks, 9.8.2
    precedence
      for first primary datafile, 9.8.2
      for LOBFILEs and SDFs, 9.8.2
    suppressing checks for, 9.8.2.1
  BYTEINT datatype, 9.4.1.5
  BYTEORDER parameter
    SQL*Loader utility, 9.8.1
  BYTEORDERMARK parameter
    SQL*Loader utility, 9.8.2.1

## C

  cached sequence numbers
    Export, 19.27.4.1
  catalog.sql script
    preparing database for Export and Import, 19.2.1
  catexp.sql script
    preparing database for Export and Import, 19.2.1
  catldr.sql script
    preparing for direct path loads, 11.4.1
  changing a database ID, 16.3.1
  changing a database name, 16.3.3
  CHAR datatype
    delimited form and SQL*Loader, 9.4.5
    reference
      SQL*Loader, 9.4.2.1
  character fields
    delimiters and SQL*Loader, 9.4.2, 9.4.5
    determining length for SQL*Loader, 9.4.6
    SQL*Loader datatypes, 9.4.2
  character set conversion
    Data Pump Import utility, 1.9
  character sets
    conversion
      during Export and Import, 19.17.1
    eight-bit to seven-bit conversions
      Export/Import, 19.17.3
    identifying for external tables, 13.2.4
    multibyte
      Export/Import, 19.17.4
      SQL*Loader, 8.10.1
    single-byte
      Export/Import, 19.17.3
    SQL*Loader control file, 8.10.5.3
    SQL*Loader conversion between, 8.10
    Unicode, 8.10.2
  character strings
    external tables
      specifying bytes or characters, 13.2.9
    SQL*Loader, 9.5.2
  character-length semantics, 8.10.5.4
  CHARACTERSET parameter
    SQL*Loader utility, 8.10.5.2
  check constraints
    overriding disabling of, 11.8.1.2
  collections, 6.10
    loading, 10.6
  column array rows
    specifying number of, 11.5.5
  column objects
    loading, 10.1
      with user-defined constructors, 10.1.6
  COLUMNARRAYROWS parameter
    SQL*Loader command line, 7.2.3
  columns
    exporting LONG datatypes, 19.27.4.2
    loading REF columns, 10.3
    naming
      SQL*Loader, 9.3
    objects
      loading nested column objects, 10.1.3
      stream record format, 10.1.1
      variable record format, 10.1.2, 10.1.2
    reordering before Import, 19.6.1
    setting to a constant value with SQL*Loader, 9.13.2
    setting to a unique sequence number with SQL*Loader, 9.13.6
    setting to an expression value with SQL*Loader, 9.13.3
    setting to null with SQL*Loader, 9.13.2.1
    setting to the current date with SQL*Loader, 9.13.5
    setting to the datafile record number with SQL*Loader, 9.13.4
    specifying
      SQL*Loader, 9.3
    specifying as PIECED
      SQL*Loader, 11.4.7.1
    using SQL*Loader, 9.13.3
  comments
    in Export and Import parameter files, 19.3.3
    with external tables, 13.1, 14.1.1
  COMMIT parameter
    Import utility, 19.10.2
  COMPILE parameter
    Import utility, 19.10.3
  completion messages
    Export, 19.14.4
    Import, 19.14.4
  COMPRESS parameter
    Export utility, 19.9.2
  compressed data
    behavior of Data Pump Import utility, 1.9
  COMPRESSION parameter
    Data Pump Export utility, 2.4.2
  CONCATENATE parameter
    SQL*Loader utility, 8.12
  concurrent conventional path loads, 11.8.4
  configuration
    of LogMiner utility, 17.2.1
  CONSISTENT parameter
    Export utility, 19.9.3
      nested tables and, 19.9.3
      partitioned table and, 19.9.3
  consolidating
    extents, 19.9.2
  CONSTANT parameter
    SQL*Loader, 9.13.2
  constraints
    automatic integrity and SQL*Loader, 11.8.2.2
    direct path load, 11.8
    disabling referential constraints, 19.6.2
    enabling
      after a parallel direct path load, 11.9.7
    enforced on a direct load, 11.8.1.1
    failed
      Import, 19.28.1.1.1
    load method, 11.3.8
  CONSTRAINTS parameter
    Export utility, 19.9.4
    Import utility, 19.10.4
  constructors
    attribute-value, 10.1.6
      overriding, 10.1.6
    user-defined, 10.1.6
      loading column objects with, 10.1.6
  CONTENT parameter
    Data Pump Export utility, 2.4.3
    Data Pump Import utility, 3.4.1
  CONTINUE_CLIENT parameter
    Data Pump Export utility
      interactive-command mode, 2.6.2
    Data Pump Import utility
      interactive-command mode, 3.6.1
  CONTINUEIF parameter
    SQL*Loader utility, 8.12
  control files
    character sets, 8.10.5.3
    creating
      guidelines, 6.3
    data definition language syntax, 8.1
    specifying data, 8.6
    specifying SQL*Loader discard file, 8.9
  CONTROL parameter
    SQL*Loader command line, 7.2.4
  conventional path Export
    compared to direct path, 19.27.1
  conventional path loads
    behavior when discontinued, 8.11.1
    compared to direct path loads, 11.3.7
    concurrent, 11.9.1
    of a single partition, 11.2
    SQL*Loader bind array, 8.16.2
    when to use, 11.2.2
  conversion of character sets
    during Export/Import, 19.17.1
    effect of character set sorting on, 19.17.1.1
  conversion of data
    during direct path loads, 11.3.1
  conversion of input characters, 8.10.5
  CREATE SESSION privilege
    Export, 19.2.3
    Import, 19.2.3
  creating
    tables
      manually, before import, 19.6.1

## D

  data
    conversion
      direct path load, 11.3.1
    delimiter marks in data and SQL*Loader, 9.4.5.4
    distinguishing different input formats for SQL*Loader, 8.15
    distinguishing different input row object subtypes, 8.15, 8.15.3
    exporting, 19.9.24
    generating unique values with SQL*Loader, 9.13.6
    including in control files, 8.6
    loading data contained in the SQL*Loader control file, 9.13.1
    loading in sections
      SQL*Loader, 11.4.7.1
    loading into more than one table
      SQL*Loader, 8.15
    maximum length of delimited data for SQL*Loader, 9.4.5.5
    moving between operating systems using SQL*Loader, 9.7
    recovery
      SQL*Loader direct path load, 11.4.6
    saving in a direct path load, 11.4.5
    saving rows
      SQL*Loader, 11.5.3
    unsorted
      SQL*Loader, 11.5.2.2
    values optimized for SQL*Loader performance, 9.13.1
  data fields
    specifying the SQL*Loader datatype, 9.3.2
  DATA parameter
    SQL*Loader command line, 7.2.5
  Data Pump Export utility
    and transparent data encryption, 2.4.6
    ATTACH parameter, 2.4.1
    command-line mode, 2.4, 3.4
    compared to original Export utility, 2.5
    COMPRESSION parameter, 2.4.2
    CONTENT parameter, 2.4.3, 2.4.3
    controlling resource consumption, 4.2.1
    dump file set, 2.1
    DUMPFILE parameter, 2.4.5
    ENCRYPTION_PASSWORD parameter, 2.4.6
    ESTIMATE parameter, 2.4.7
    ESTIMATE_ONLY parameter, 2.4.8
    EXCLUDE parameter, 2.4.9
    excluding objects, 2.4.9
    export modes, 2.2.2
    FILESIZE command
      interactive-command mode, 2.6.4
    FILESIZE parameter, 2.4.10
    filtering data that is exported
      using EXCLUDE parameter, 2.4.9
      using INCLUDE parameter, 2.4.15
    FLASHBACK_SCN parameter, 2.4.11
    FLASHBACK_TIME parameter, 2.4.12
    FULL parameter, 2.4.13
    HELP parameter
      interactive-command mode, 2.6.5
    INCLUDE parameter, 2.4.15
    interactive-command mode, 2.6
      ADD_FILE parameter, 2.6.1
      CONTINUE_CLIENT parameter, 2.6.2
      EXIT_CLIENT parameter, 2.6.3
      FILESIZE, 2.6.4
      HELP parameter, 2.6.5
      KILL_JOB parameter, 2.6.6
      PARALLEL parameter, 2.6.7
      START_JOB parameter, 2.6.8
      STATUS parameter, 2.6.9
      STOP_JOB parameter, 2.6.10, 3.6.8
    interfaces, 2.2.1
    invoking
      as SYSDBA, 2.2, 3.2
    job names
      specifying, 2.4.16
    JOB_NAME parameter, 2.4.16
    LOGFILE parameter, 2.4.17
    NETWORK_LINK parameter, 2.4.18
    NOLOGFILE parameter, 2.4.19
    PARALLEL parameter
      command-line mode, 2.4.20
      interactive-command mode, 2.6.7
    PARFILE parameter, 2.4.21
    QUERY parameter, 2.4.22
    SAMPLE parameter, 2.4.23
    SCHEMAS parameter, 2.4.24
    specifying a job name, 2.4.16
    syntax diagrams, 2.8
    TABLES parameter, 2.4.26
    TABLESPACES parameter, 2.4.27
    TRANSPORT_FULL_CHECK parameter, 2.4.28
    TRANSPORT_TABLESPACES parameter, 2.4.29
    VERSION parameter, 2.4.30
    versioning, 1.8
  Data Pump Import utility
    and transparent data encryption, 3.4.5
    ATTACH parameter, 3.4.1
    attaching to an existing job, 3.4.1
    changing name of source datafile, 3.4.20
    character set conversion, 1.9
    command-line mode
      NOLOGFILE parameter, 3.4.16
      STATUS parameter, 3.4.27
    compared to original Import utility, 3.5
    CONTENT parameter, 3.4.2
    controlling resource consumption, 4.2.1
    data compression, 1.9
    data filters, 3.3.1
    DIRECTORY parameter, 3.4.3
    DUMPFILE parameter, 3.4.4
    ENCRYPTION_PASSWORD parameter, 3.4.5
    ESTIMATE parameter, 3.4.6
    estimating size of job, 3.4.6
    EXCLUDE parameter, 3.4.7
    filtering data that is imported
      using EXCLUDE parameter, 3.4.7
      using INCLUDE parameter, 3.4.12
    FLASHBACK_SCN parameter, 3.4.8
    FLASHBACK_TIME parameter, 3.4.9
    full import mode, 3.2.2.1
    FULL parameter, 3.4.10
    HELP parameter
      command-line mode, 3.4.11
      interactive-command mode, 3.6.3
    importing entire source, 3.4.10
    INCLUDE parameter, 3.4.12
    interactive-command mode, 3.6
      CONTINUE_CLIENT parameter, 3.6.1
      EXIT_CLIENT parameter, 3.6.2
      HELP parameter, 3.6.3
      KILL_JOB parameter, 3.6.4
      START_JOB parameter, 3.6.6
      STATUS parameter, 3.4.27, 3.6.7
      STOP_JOB parameter, 3.6.8
    interfaces, 3.2.1
    JOB_NAME parameter, 3.4.13
    LOGFILE parameter, 3.4.14
    network mode
      enabling, 3.4.15
    NETWORK_LINK parameter, 3.4.15
    PARALLEL parameter
      command-line mode, 3.4.17
      interactive-command mode, 3.6.5
    PARFILE parameter, 3.4.18
    QUERY parameter, 3.4.19
    REMAP_DATAFILE parameter, 3.4.20
    REMAP_SCHEMA parameter, 3.4.21
    REMAP_TABLESPACE parameter, 3.4.22
    REUSE_DATAFILES parameter, 3.4.23
    schema mode, 3.2.2.2
    SCHEMAS parameter, 3.4.24
    SKIP_UNUSABLE_INDEXES parameter, 3.4.25
    specifying a job name, 3.4.13
    specifying dump file set to import, 3.4.4
    SQLFILE parameter, 3.4.26
    STREAMS_CONFIGURATION parameter, 3.4.28
    syntax diagrams, 3.8
    table mode, 3.2.2.3
    TABLE_EXISTS_ACTION parameter, 3.4.29
    TABLES parameter, 3.4.30
    tablespace mode, 3.2.2.4
    TABLESPACES parameter, 3.4.31
    TRANSFORM parameter, 3.4.32
    TRANSPORT_DATAFILES parameter, 3.4.33
    TRANSPORT_FULL_CHECK parameter, 3.4.34
    TRANSPORT_TABLESPACES parameter, 2.4.29, 3.4.35
    transportable tablespace mode, 3.2.2.5
    VERSION parameter, 3.4.36
    versioning, 1.8
  database ID (DBID)
    changing, 16.3.1
  database identifier
    changing, 16.3.1
  database migration
    partitioning of, 19.29
  database name (DBNAME)
    changing, 16.3.3
  database objects
    exporting LONG columns, 19.27.4.2
  databases
    changing the database ID, 16.3.1
    changing the name, 16.3.3
    exporting entire, 19.9.11
    full import, 19.10.11
    moving between platforms, 19.13
    privileges for exporting and importing, 19.2.3
    reducing fragmentation, 19.25
    reusing existing datafiles
      Import, 19.10.6
  datafiles
    preventing overwrite during import, 19.10.6
    reusing during import, 19.10.6
    specifying, 7.2.5
    specifying buffering for SQL*Loader, 8.7
    specifying for SQL*Loader, 8.5
    specifying format for SQL*Loader, 8.7
  DATAFILES parameter
    Import utility, 19.10.5
  datatypes
    BFILE
      Export, 19.27.4.6
      Import, 19.28.5.5
    BYTEINT, 9.4.1.5
    CHAR, 9.4.2.1
    converting SQL*Loader, 9.4.3
    DATE, 9.4.2.2.1
    datetime, 9.4.2.2
    DECIMAL, 9.4.1.7
    default in SQL*Loader, 9.3.2
    describing for external table fields, 13.3.6
    determining character field lengths for SQL*Loader, 9.4.6
    determining DATE length, 9.4.6.3
    DOUBLE, 9.4.1.4
    FLOAT, 9.4.1.3
    GRAPHIC, 9.4.2.3
    GRAPHIC EXTERNAL, 9.4.2.4
    identifying for external tables, 13.3.4
    INTEGER (n), 9.4.1.1
    interval, 9.4.2.2
    length-value, 9.4, 9.4
    LONG
      Export, 19.27.4.2
      Import, 19.28.5.11, 19.28.5.11
    LONG VARRAW, 9.4.1.11
    native
      conflicting length specifications in SQL*Loader, 9.4.2.9
    nonportable, 9.4.1
    nonscalar, 10.1.5
    NUMBER
      SQL*Loader, 9.4.3, 9.4.4
    numeric EXTERNAL, 9.4.2.5
    portable, 9.4.2
    RAW, 9.4.2.6
    SMALLINT, 9.4.1.2
    specifying the SQL*Loader datatype of a data field, 9.3.2
    supported by the LogMiner utility, 17.13.1
    unsupported by LogMiner utility, 17.13.2
    value, 9.4, 9.4
    VARCHAR, 9.4.1.9
    VARCHAR2
      SQL*Loader, 9.4.3
    VARCHARC, 9.4.2.7
    VARGRAPHIC, 9.4.1.8
    VARRAW, 9.4.1.10
    VARRAWC, 9.4.2.8
    ZONED, 9.4.1.6
  date cache feature
    DATE_CACHE parameter, 7.2.6
    external tables, 12.5.1
    SQL*Loader, 11.5.6
  DATE datatype
    delimited form and SQL*Loader, 9.4.5
    determining length, 9.4.6.3
    mask
      SQL*Loader, 9.4.6.3
    SQL*Loader, 9.4.2.2.1
  DATE_CACHE parameter
    SQL*Loader utility, 7.2.6
  datetime datatypes, 9.4.2.2
  DBID (database identifier)
    changing, 16.3.1
  DBMS_DATAPUMP PL/SQL package, 5
  DBMS_LOGMNR PL/SQL procedure
    LogMiner utility and, 17.2.2
  DBMS_LOGMNR_D PL/SQL procedure
    LogMiner utility and, 17.2.2
  DBMS_LOGMNR_D.ADD_LOGFILES PL/SQL procedure
    LogMiner utility and, 17.2.2
  DBMS_LOGMNR_D.BUILD PL/SQL procedure
    LogMiner utility and, 17.2.2
  DBMS_LOGMNR_D.END_LOGMNR PL/SQL procedure
    LogMiner utility and, 17.2.2
  DBMS_LOGMNR.ADD_LOGFILE PL/SQL procedure
    ADDFILE option, 17.3.2
    NEW option, 17.3.2
  DBMS_LOGMNR.COLUMN_PRESENT function, 17.5.2
  DBMS_LOGMNR.MINE_VALUE function, 17.5.2
    null values and, 17.5.2.1
  DBMS_LOGMNR.START_LOGMNR PL/SQL procedure, 17.4
    calling multiple times, 17.8
    COMMITTED_DATA_ONLY option, 17.6.1
    CONTINUOUS_MINE option, 17.3.2
    ENDTIME parameter, 17.6.3, 17.6.4
    LogMiner utility and, 17.2.2
    options for, 17.4
    PRINT_PRETTY_SQL option, 17.6.6
    SKIP_CORRUPTION option, 17.6.2
    STARTTIME parameter, 17.6.3, 17.6.4
  DBMS_METADATA PL/SQL package, 18.3.1
  DBNAME
    changing, 16.3.3
  DBNEWID utility, 16
    changing a database ID, 16.3.1
    changing a database name, 16.3.3
    effect on global database names, 16.2.1
    restrictions, 16.4.2
    syntax, 16.4
    troubleshooting a database ID change, 16.3.4
  DBVERIFY utility
    output, 15.1.4
    restrictions, 15
    syntax, 15.1.1
    validating a segment, 15.2
    validating disk blocks, 15.1
  DECIMAL datatype, 9.4.1.7
    EXTERNAL format
      SQL*Loader, 9.4.2.5
  default schema
    as determined by SQL*Loader, 8.13.1.1
  DEFAULTIF parameter
    SQL*Loader, 9.5
  DELETE ANY TABLE privilege
    SQL*Loader, 8.13.2.2.4
  DELETE CASCADE
    effect on loading nonempty tables, 8.13.2.2.2
    SQL*Loader, 8.13.2.2.4
  DELETE privilege
    SQL*Loader, 8.13.2.2.2
  delimited data
    maximum length for SQL*Loader, 9.4.5.5
  delimited fields
    field length, 9.4.6.2
  delimited LOBs, 10.4.2.2.3
  delimiters
    in external tables, 13.2.3
    loading trailing blanks, 9.4.5.6
    marks in data and SQL*Loader, 9.4.5.4
    specifying for external tables, 13.3.1
    specifying for SQL*Loader, 8.13.5, 9.4.5
    SQL*Loader enclosure, 9.10.2.2
    SQL*Loader field specifications, 9.10.2.2
    termination, 9.10.2.2
  DESTROY parameter
    Import utility, 19.10.6
  dictionary
    requirements for LogMiner utility, 17.2.1.2
  dictionary version mismatch, 17.9.4
  DIRECT parameter
    Export utility, 19.9.5
  direct path Export, 19.27.1, 19.27.2
    compared to conventional path, 19.27.1
    effect of EXEMPT ACCESS POLICY privilege, 19.27.2.1
    performance issues, 19.27.2.2
    restrictions, 19.27.2.3
    security considerations, 19.27.2.1
  direct path load
    advantages, 11.3.4
    behavior when discontinued, 8.11.2
    choosing sort order
      SQL*Loader, 11.5.2.4
    compared to conventional path load, 11.3.7
    concurrent, 11.9.3, 11.9.3
    conditions for use, 11.3.5
    data saves, 11.4.5, 11.5.3
    DIRECT command-line parameter
      SQL*Loader, 11.4.2
    dropping indexes, 11.7
    effect of disabling archiving, 11.5.4
    effect of PRIMARY KEY constraints, 11.9.8
    effect of UNIQUE KEY constraints, 11.9.8
    field defaults, 11.3.9
    improper sorting
      SQL*Loader, 11.5.2.2
    indexes, 11.4.3
    instance recovery, 11.4.6
    intersegment concurrency, 11.9.3
    intrasegment concurrency, 11.9.3
    loading into synonyms, 11.3.10
    location of data conversion, 11.3.1
    media recovery, 11.4.6.1, 11.4.6.1
    optimizing on multiple-CPU systems, 11.6
    partitioned load
      SQL*Loader, 11.8.4
    performance, 11.4.3, 11.5
    preallocating storage, 11.5.1
    presorting data, 11.5.2
    recovery, 11.4.6
    ROWS command-line parameter, 11.4.5.1
    setting up, 11.4.1
    specifying, 11.4.2
    specifying number of rows to be read, 7.2.22
    SQL*Loader data loading method, 6.9.2
    table insert triggers, 11.8.2
    temporary segment storage requirements, 11.4.3.2
    triggers, 11.8
    using, 11.3.7, 11.4
    version requirements, 11.3.5
  directory aliases
    exporting, 19.27.4.5
    importing, 19.28.5.5
  directory objects
    Data Pump
      effect of automatic storage management, 1.7.2.1
    using with Data Pump, 1.7.2.1
  DIRECTORY parameter
    Data Pump Export utility, 2.4.4
    Data Pump Import utility, 3.4.3
  discard files
    SQL*Loader, 8.9
      specifying a maximum, 8.9.2
  DISCARD parameter
    SQL*Loader command-line, 7.2.8
  discarded SQL*Loader records, 6.7
    causes, 8.9.4
    discard file, 8.9
    limiting, 8.9.6
  DISCARDMAX parameter
    SQL*Loader command-line, 7.2.9
  discontinued loads, 8.11
    continuing, 8.11.5
    conventional path behavior, 8.11.1
    direct path behavior, 8.11.2
  DOUBLE datatype, 9.4.1.4
  dropped snapshots
    Import, 19.18.2.1
  dump files
    maximum size, 19.9.8
  DUMPFILE parameter
    Data Pump Export utility, 2.4.5
    Data Pump Import utility, 3.4.4

## E

  EBCDIC character set
    Import, 19.17.3
  eight-bit character set support, 19.17.3
  enclosed fields
    specified with enclosure delimiters and SQL*Loader, 9.4.5.2
    whitespace, 9.10.6
  enclosure delimiters, 9.4.5
    SQL*Loader, 9.4.5.2, 9.10.2.2
  encrypted columns
    in external tables, 14.1.4
  ENCRYPTION_PASSWORD parameter
    Data Pump Export utility, 2.4.6
    Data Pump Import utility, 3.4.5
  errors
    caused by tab characters in SQL*Loader data, 9.2.1
    LONG data, 19.28.1.1.2
    object creation, 19.28.1.2.1
      Import parameter IGNORE, 19.10.14
    resource errors on import, 19.28.1.2.3
    row errors during import, 19.28.1.1
    writing to export log file, 19.9.15
  ERRORS parameter
    SQL*Loader command line, 7.2.10
  escape character
    quoted strings and, 8.3.3.2
    usage in Data Pump Export, 2.4
    usage in Data Pump Import, 3.4
    usage in Export, 19.9.26.1
    usage in Import, 19.10.29
  ESTIMATE parameter
    Data Pump Export utility, 2.4.7
    Data Pump Import utility, 3.4.6
  ESTIMATE_ONLY parameter
    Data Pump Export utility, 2.4.8
  estimating size of job
    Data Pump Export utility, 2.4.7
  EVALUATE CHECK_CONSTRAINTS clause, 11.8.1.2
  EXCLUDE parameter
    Data Pump Export utility, 2.4.9
    Data Pump Import utility, 3.4.7
  exit codes
    Export and Import, 19.15
    SQL*Loader, 7.3
  EXIT_CLIENT parameter
    Data Pump Export utility
      interactive-command mode, 2.6.3
    Data Pump Import utility
      interactive-command mode, 3.6.2
  EXP_FULL_DATABASE role
    assigning in Export, 19.2.1
  expdat.dmp
    Export output file, 19.9.7
  Export
    BUFFER parameter, 19.9.1
    character set conversion, 19.17.1
    COMPRESS parameter, 19.9.2
    CONSISTENT parameter, 19.9.3
    CONSTRAINTS parameter, 19.9.4
    conventional path, 19.27.1
    creating
      necessary privileges, 19.2.1
      necessary views, 19.2.1
    database optimizer statistics, 19.9.25
    DIRECT parameter, 19.9.5
    direct path, 19.27.1
    displaying online help, 19.9.13
    example sessions, 19.11
      full database mode, 19.11.1
      partition-level, 19.11.4
      table mode, 19.11.3
      user mode, 19.9.17, 19.11.2
    exit codes, 19.15
    exporting an entire database, 19.9.11
    exporting indexes, 19.9.14
    exporting sequence numbers, 19.27.4.1
    exporting synonyms, 19.27.4.11
    exporting to another operating system, 19.9.20, 19.10.19
    FEEDBACK parameter, 19.9.6
    FILE parameter, 19.9.7
    FILESIZE parameter, 19.9.8
    FLASHBACK_SCN parameter, 19.9.9
    FLASHBACK_TIME parameter, 19.9.10
    full database mode
      example, 19.11.1
    FULL parameter, 19.9.11
    GRANTS parameter, 19.9.12
    HELP parameter, 19.9.13
    INDEXES parameter, 19.9.14
    invoking, 19.3
    log files
      specifying, 19.9.15
    LOG parameter, 19.9.15
    logging error messages, 19.9.15
    LONG columns, 19.27.4.2
    OBJECT_CONSISTENT parameter, 19.9.16
    online help, 19.3.5
    OWNER parameter, 19.9.17
    parameter file, 19.9.18
      maximum size, 19.3.3
    parameter syntax, 19.9
    PARFILE parameter, 19.9.18
    partitioning a database migration, 19.29
    QUERY parameter, 19.9.19
    RECORDLENGTH parameter, 19.9.20
    redirecting output to a log file, 19.14.1
    remote operation, 19.16.2
    restrictions based on privileges, 19.2.3
    RESUMABLE parameter, 19.9.21
    RESUMABLE_NAME parameter, 19.9.22
    RESUMABLE_TIMEOUT parameter, 19.9.23
    ROWS parameter, 19.9.24
    sequence numbers, 19.27.4.1
    STATISTICS parameter, 19.9.25
    storage requirements, 19.2.2
    table mode
      example session, 19.11.3
    table name restrictions, 19.9.26.1
    TABLES parameter, 19.9.26
    TABLESPACES parameter, 19.9.27
    TRANSPORT_TABLESPACE parameter, 19.9.28
    TRIGGERS parameter, 19.9.29
    TTS_FULL_CHECK parameter, 19.9.30
    user access privileges, 19.2.3
    user mode
      example session, 19.9.17, 19.11.2
      specifying, 19.9.17
    USERID parameter, 19.9.31
    VOLSIZE parameter, 19.9.32
  export dump file
    importing the entire file, 19.10.11
  export file
    listing contents before importing, 19.10.24
    specifying, 19.9.7
  EXPRESSION parameter
    SQL*Loader, 9.13.3, 9.13.3.1
  extents
    consolidating, 19.9.2
    importing consolidated, 19.26.4
  external files
    exporting, 19.27.4.6
  EXTERNAL parameter
    SQL*Loader, 9.4.2.5
  EXTERNAL SQL*Loader datatypes, 9.4.2.5
    DECIMAL, 9.4.2.5
    FLOAT, 9.4.2.5
    GRAPHIC, 9.4.2.4
    numeric, 9.4.2.5
      determining len, 9.4.6
    ZONED, 9.4.2.5
  external tables
    and encrypted columns, 14.1.4
    big-endian data, 13.2.7
    column_transforms clause, 13.1
    datatypes, 13.3.6
    date cache feature, 12.5.1
    delimiters, 13.2.3
    describing datatype of a field, 13.3.6
    differences in load behavior from SQL*Loader, 12.7
    field_definitions clause, 13.1, 13.3
    fixed-length records, 13.2.1
    identifying character sets, 13.2.4
    identifying datatypes, 13.3.4
    improving performance when using, 12.5
      date cache feature, 12.5.1
    little-endian data, 13.2.7
    record_format_info clause, 13.1, 13.2
    reserved words, 12.6
    restrictions, 12.6
    setting a field to a default value, 13.3.7
    setting a field to null, 13.3.7
    skipping records when loading data, 13.2.14
    specifying delimiters, 13.3.1
    specifying load conditions, 13.2.10
    trimming blanks, 13.3.2
    using comments, 13.1, 14.1.1
    using constructor functions with, 12.2.3
    using to load data, 12.2
    variable-length records, 13.2.2
  EXTERNAL_TABLE parameter
    SQL*Loader, 7.2.11

## F

  fatal errors
    See nonrecoverable error messages
  FEEDBACK parameter
    Export utility, 19.9.6
    Import utility, 19.10.7
  field conditions
    specifying for SQL*Loader, 9.5
  field length
    SQL*Loader specifications, 9.10.2
  field location
    SQL*Loader, 9.2
  fields
    character data length and SQL*Loader, 9.4.6
    comparing to literals with SQL*Loader, 9.5.2
    delimited
      determining length, 9.4.6.2
      SQL*Loader, 9.4.5
    enclosed and SQL*Loader, 9.4.5.2
    loading all blanks, 9.9
    predetermined size
      length, 9.4.6.1
      SQL*Loader, 9.10.2.1
    relative positioning and SQL*Loader, 9.10.3
    specified with a termination delimiter and SQL*Loader, 9.4.5.1
    specified with enclosure delimiters and SQL*Loader, 9.4.5.2
    specifying default delimiters for SQL*Loader, 8.13.5
    specifying for SQL*Loader, 9.3
    SQL*Loader delimited
      specifications, 9.10.2.2
    terminated and SQL*Loader, 9.4.5.1
  FIELDS clause
    SQL*Loader, 8.13.5
    terminated by whitespace, 9.10.4.1
  FILE parameter
    Export utility, 19.9.7
    Import utility, 19.10.8
    SQL*Loader utility, 11.9.6.1
  filenames
    quotation marks and, 8.3.3.1
    specifying multiple SQL*Loader, 8.5.2
    SQL*Loader, 8.3
    SQL*Loader bad file, 8.8
  FILESIZE parameter
    Data Pump Export utility, 2.4.10
    Export utility, 19.9.8
    Import utility, 19.10.9
  FILLER field
    using as argument to init_spec, 9.3.1
  filtering data
    using Data Pump Export utility, 2.1
    using Data Pump Import utility, 3.1
  filtering metadata that is imported
    Data Pump Import utility, 3.4.7
  fine-grained access support
    Export and Import, 19.23
  fixed-format records, 6.4.1
  fixed-length records
    external tables, 13.2.1
  FLASHBACK_SCN parameter
    Data Pump Export utility, 2.4.11
    Data Pump Import utility, 3.4.8
    Export utility, 19.9.9
  FLASHBACK_TIME parameter
    Data Pump Export utility, 2.4.12
    Data Pump Import utility, 3.4.9
    Export utility, 19.9.10
  FLOAT datatype, 9.4.1.3
    EXTERNAL format
      SQL*Loader, 9.4.2.5
  FLOAT EXTERNAL data values
    SQL*Loader, 9.4.2.5
  foreign function libraries
    exporting, 19.27.4.3
    importing, 19.28.5.6, 19.28.5.9
  formats
    SQL*Loader input records and, 8.15.2
  formatting errors
    SQL*Loader, 8.8
  fragmentation
    reducing, 19.25
  FROMUSER parameter
    Import utility, 19.10.10
  full database mode
    Import, 19.10.11
    specifying with FULL, 19.9.11
  full export mode
    Data Pump Export utility, 2.2.2.1
  FULL parameter
    Data Pump Export utility, 2.4.13
    Data Pump Import utility, 3.4.10
    Export utility, 19.9.11
    Import utility, 19.10.11

## G

  globalization
    SQL*Loader, 8.10
  grants
    exporting, 19.9.12
    importing, 19.4.1, 19.10.12
  GRANTS parameter
    Export utility, 19.9.12
    Import utility, 19.10.12
  GRAPHIC datatype
    EXTERNAL format in SQL*Loader, 9.4.2.4

## H

  HELP parameter
    Data Pump Export utility
      command-line mode, 2.4.14
      interactive-command mode, 2.6.5
    Data Pump Import utility
      command-line mode, 3.4.11
      interactive-command mode, 3.6.3
    Export utility, 19.9.13
    Import utility, 19.10.13
  hexadecimal strings
    SQL*Loader, 9.5.2

## I

  IGNORE parameter
    Import utility, 19.10.14
  IMP_FULL_DATABASE role
    assigning in Import, 19.2.1
  Import
    BUFFER parameter, 19.10.1
    character set conversion, 19.17.1, 19.17.3
    COMMIT parameter, 19.10.2
    committing after array insert, 19.10.2
    COMPILE parameter, 19.10.3
    consolidated extents, 19.26.4
    CONSTRAINTS parameter, 19.10.4
    creating
      necessary privileges, 19.2.1
      necessary views, 19.2.1
    creating an index-creation SQL script, 19.10.16
    database optimizer statistics, 19.10.26
    DATAFILES parameter, 19.10.5
    DESTROY parameter, 19.10.6
    disabling referential constraints, 19.6.2, 19.6.2
    displaying online help, 19.10.13
    dropping a tablespace, 19.21
    errors importing database objects, 19.28.1.2
    example sessions, 19.12
      all tables from one user to another, 19.12.3
      selected tables for specific user, 19.12.1
      tables exported by another user, 19.12.2
      using partition-level Import, 19.12.4
    exit codes, 19.15
    export file
      importing the entire file, 19.10.11
      listing contents before import, 19.10.24
    failed integrity constraints, 19.28.1.1.1
    FEEDBACK parameter, 19.10.7
    FILE parameter, 19.10.8
    FILESIZE parameter, 19.10.9
    FROMUSER parameter, 19.10.10
    FULL parameter, 19.10.11
    grants
      specifying for import, 19.10.12
    GRANTS parameter, 19.10.12
    HELP parameter, 19.10.13
    IGNORE parameter, 19.10.14
    importing grants, 19.10.12
    importing objects into other schemas, 19.4.2
    importing rows, 19.10.23
    importing tables, 19.10.29
    INDEXES parameter, 19.10.15
    INDEXFILE parameter, 19.10.16
    INSERT errors, 19.28.1.1.2
    invalid data, 19.28.1.1.2
    invoking, 19.3
    LOG parameter, 19.10.17
    LONG columns, 19.28.5.11, 19.28.5.11
    manually creating tables before import, 19.6.1
    manually ordering tables, 19.6.3
    NLS_LANG environment variable, 19.17.3
    object creation errors, 19.10.14
    online help, 19.3.5
    parameter file, 19.10.18
      maximum size, 19.3.3
    parameter syntax, 19.10
    PARFILE parameter, 19.10.18
    partition-level, 19.8.2
    pattern matching of table names, 19.10.29
    preserving size of initial extent, 19.26.4
    read-only tablespaces, 19.20
    RECORDLENGTH parameter, 19.10.19
    records
      specifying length, 19.10.19
    redirecting output to a log file, 19.14.1
    reducing database fragmentation, 19.25
    refresh error, 19.18.1
    remote operation, 19.16.2
    reorganizing tablespace during, 19.22
    resource errors, 19.28.1.2.3
    restrictions
      importing into own schema, 19.4
    RESUMABLE parameter, 19.10.20
    RESUMABLE_NAME parameter, 19.10.21
    RESUMABLE_TIMEOUT parameter, 19.10.22
    reusing existing datafiles, 19.10.6
    rows
      specifying for import, 19.10.23
    ROWS parameter, 19.10.23
    schema objects, 19.4.2
    sequences, 19.28.1.2.2
    SHOW parameter, 19.10.24
    single-byte character sets, 19.17.3
    SKIP_UNUSABLE_INDEXES parameter, 19.10.25
    snapshot master table, 19.18.1
    snapshots, 19.18
      restoring dropped, 19.18.2.1
    specifying by user, 19.10.10
    specifying index creation commands, 19.10.16
    specifying the export file, 19.10.8
    STATISTICS parameter, 19.10.26
    storage parameters
      overriding, 19.26.3
    stored functions, 19.28.5.7
    stored procedures, 19.28.5.7
    STREAMS_CONFIGURATION parameter, 19.10.27
    STREAMS_INSTANTIATION parameter, 19.10.28
    system objects, 19.4.3
    table name restrictions, 19.10.29.1
    table objects
      import order, 19.5
    table-level, 19.8.2
    TABLES parameter, 19.10.29
    TABLESPACES parameter, 19.10.30
    TOID_NOVALIDATE parameter, 19.10.31
    TOUSER parameter, 19.10.32
    TRANSPORT_TABLESPACE parameter, 19.10.33
    TTS_OWNER parameter, 19.10.34
    tuning considerations, 19.28.4
    types of errors during, 19.28.1
    user access privileges, 19.2.3
    USERID parameter, 19.10.35
    VOLSIZE parameter, 19.10.36
  INCLUDE parameter
    Data Pump Export utility, 2.4.15
    Data Pump Import utility, 3.4.12
  index options
    SORTED INDEXES with SQL*Loader, 8.14.1
    SQL*Loader SINGLEROW parameter, 8.14.2
  Index Unusable state
    indexes left in Index Unusable state, 8.11.3, 11.4.4
  indexes
    creating manually, 19.10.16
    direct path load
      left in direct load state, 11.4.4
    dropping
      SQL*Loader, 11.7
    estimating storage requirements, 11.4.3.1
    exporting, 19.9.14
    importing, 19.10.15
    index-creation commands
      Import, 19.10.16
    left in unusable state, 8.11.3, 11.5.2.2
    multiple-column
      SQL*Loader, 11.5.2.3
    presorting data
      SQL*Loader, 11.5.2
    skipping maintenance, 7.2.25, 11.7
    skipping unusable, 7.2.26, 11.7
    SQL*Loader, 8.14
    state after discontinued load, 8.11.3
    unique, 19.10.15
  INDEXES parameter
    Export utility, 19.9.14
    Import utility, 19.10.15
  INDEXFILE parameter
    Import utility, 19.10.16
  INFILE parameter
    SQL*Loader utility, 8.5
  insert errors
    Import, 19.28.1.1.2
    specifying, 7.2.10
  INSERT into table
    SQL*Loader, 8.13.2.1.1
  instance affinity
    Export and Import, 19.24
  instance recovery, 11.4.6.2
  INTEGER datatype, 9.4.1.1
    EXTERNAL format, 9.4.2.5
  integrity constraints
    disabled during direct path load, 11.8.1.2
    enabled during direct path load, 11.8.1.1
    failed on Import, 19.28.1.1.1
    load method, 11.3.8
  interactive method
    Data Pump Export utility, 2.2.1
    original Export and Import, 19.3.4
  internal LOBs
    loading, 10.4.1
  interrupted loads, 8.11
  interval datatypes, 9.4.2.2
  INTO TABLE statement
    effect on bind array size, 8.16.6
    multiple statements with SQL*Loader, 8.15
    SQL*Loader, 8.13
      column names, 9.3
      discards, 8.9.4
  invalid data
    Import, 19.28.1.1.2
  invoking
    Export, 19.3
      at the command line, 19.3.2
      direct path, 19.27.2
      interactively, 19.3.4
      with a parameter file, 19.3.3
    Import, 19.3
      as SYSDBA, 19.3.1
      at the command line, 19.3.2
      interactively, 19.3.4
      with a parameter file, 19.3.3

## J

  JOB_NAME parameter
    Data Pump Export utility, 2.4.16
    Data Pump Import utility, 3.4.13

## K

  key values
    generating with SQL*Loader, 9.13.6
  KILL_JOB parameter
    Data Pump Export utility
      interactive-command mode, 2.6.6
    Data Pump Import utility, 3.6.4

## L

  leading whitespace
    definition, 9.10.1
    trimming and SQL*Loader, 9.10.4
  length indicator
    determining size, 8.16.4.1
  length subfield
    VARCHAR DATA
      SQL*Loader, 9.4.1.9
  length-value datatypes, 9.4, 9.4
  length-value pair specified LOBs, 10.4.2.2.4
  libraries
    foreign function
      exporting, 19.27.4.3
      importing, 19.28.5.6, 19.28.5.9
  little-endian data
    external tables, 13.2.7
  LOAD parameter
    SQL*Loader command line, 7.2.13
  loading
    collections, 10.6
    column objects, 10.1
      in variable record format, 10.1.2
      with a derived subtype, 10.1.4
      with user-defined constructors, 10.1.6
    datafiles containing tabs
      SQL*Loader, 9.2.1
    external table data
      skipping records, 13.2.14
      specifying conditions, 13.2.7, 13.2.18
    into LONG RAW columns, 9.4.3
    LOBs, 10.4
    nested column objects, 10.1.3
    object tables, 10.2
    object tables with a subtype, 10.2.1
    REF columns, 10.3
    subpartitioned tables, 11.3.2
    tables, 11.3.2
    XML columns, 10.4
  LOB data, 6.5
    compression during export, 19.9.2
    Export, 19.27.4.2
    in delimited fields, 10.4.1.2
    in length-value pair fields, 10.4.1.3
    in predetermined size fields, 10.4.1.1
  LOB read buffer
    size of, 7.2.18
  LOBFILEs, 6.5, 10.4, 10.4.2
  LOBs
    loading, 10.4
  log files
    after a discontinued load, 8.11.4
    Export, 19.9.15, 19.14.1
    Import, 19.10.17, 19.14.1
    specifying for SQL*Loader, 7.2.14
    SQL*Loader, 6.8
  LOG parameter
    Export utility, 19.9.15
    Import utility, 19.10.17
    SQL*Loader command line, 7.2.14
  LOGFILE parameter
    Data Pump Export utility, 2.4.17
    Data Pump Import utility, 3.4.14
  logical records
    consolidating multiple physical records using SQL*Loader, 8.12
  LogMiner utility
    accessing redo data of interest, 17.5
    adjusting redo log file list, 17.8
    analyzing output, 17.5.1
    configuration, 17.2.1
    considerations for reapplying DDL statements, 17.7
    current log file list
      stored information about, 17.10.1
    DBMS_LOGMNR PL/SQL procedure and, 17.2.2
    DBMS_LOGMNR_D PL/SQL procedure and, 17.2.2
    DBMS_LOGMNR_D.ADD_LOGFILES PL/SQL procedure and, 17.2.2
    DBMS_LOGMNR_D.BUILD PL/SQL procedure and, 17.2.2
    DBMS_LOGMNR_D.END_LOGMNR PL/SQL procedure and, 17.2.2
    DBMS_LOGMNR.START_LOGMNR PL/SQL procedure and, 17.2.2
    DDL tracking
      time or SCN ranges, 17.9.6
    determining redo log files being analyzed, 17.3.2
    dictionary
      purpose of, 17.2.1
    dictionary extracted to flat file
      stored information about, 17.10
    dictionary options, 17.3.1
      flat file and, 17.3.1
      online catalog and, 17.3.1
      redo log files and, 17.3.1
    ending a session, 17.11.6
    executing reconstructed SQL, 17.6.5
    extracting data values from redo logs, 17.5.2
    filtering data by SCN, 17.6.4
    filtering data by time, 17.6.3
    formatting returned data, 17.6.6
    graphical user interface, 17
    levels of supplemental logging, 17.9
    LogMiner dictionary defined, 17.2.1
    mining a subset of data in redo log files, 17.8
    mining database definition for, 17.2.1
    operations overview, 17.2.2
    parameters
      stored information about, 17.10
    redo log files
      on a remote database, 17.8
      stored information about, 17.10
    requirements for dictionary, 17.2.1.2
    requirements for redo log files, 17.2.1.2
    requirements for source and mining databases, 17.2.1.2
    sample configuration, 17.2.1.1
    showing committed transactions only, 17.6.1
    skipping corruptions, 17.6.2
    source database definition for, 17.2.1
    specifying redo log files to mine, 17.3.2
      automatically, 17.3.2
      manually, 17.3.2
    specifying redo logs for analysis, 17.11.3
    starting, 17.4, 17.11.4
    starting multiple times within a session, 17.8
    steps for extracting dictionary to a flat file, 17.3.1.3
    steps for extracting dictionary to redo log files, 17.3.1.2
    steps for using dictionary in online catalog, 17.3.1.1
    steps in a typical session, 17.11
    supplemental log groups, 17.9
      conditional, 17.9
      unconditional, 17.9
    supplemental logging, 17.9
      database level, 17.9.1
      database-level identification keys, 17.9.1.2
      disabling database-level, 17.9.2
      interactions with DDL tracking, 17.9.5
      log groups, 17.9
      minimal, 17.9.1.1
      stored information about, 17.10
      table-level identification keys, 17.9.3.1
      table-level log groups, 17.9.3.2
      user-defined log groups, 17.9.3.3
    supported database versions, 17.13.3
    supported datatypes, 17.13.1
    supported redo log file versions, 17.13.3
    suppressing delimiters in SQL_REDO and SQL_UNDO, 17.6.5
    table-level supplemental logging, 17.9.3
    tracking DDL statements, 17.9.4
      requirements, 17.9.4
    unsupported datatypes, 17.13.2
    using the online catalog, 17.3.1.1
    using to analyze redo log files, 17
    V$DATABASE view, 17.10
    V$LOGMNR_CONTENTS view, 17.2.2, 17.5.1, 17.6
    V$LOGMNR_DICTIONARY view, 17.10
    V$LOGMNR_LOGS view, 17.10
      querying, 17.10.1
    V$LOGMNR_PARAMETERS view, 17.9.6, 17.10
    views, 17.10
  LogMiner Viewer, 17
  LONG data
    C language datatype LONG FLOAT, 9.4.1.4
    exporting, 19.27.4.2
    importing, 19.28.5.11
  LONG VARRAW datatype, 9.4.1.11

## M

  master tables
    Oracle Data Pump API, 1.5.2
    snapshots
      original Import, 19.18.1
  materialized views, 19.18
  media recovery
    direct path load, 11.4.6.1
  Metadata API, 18
    enhancing performance, 18.6
    retrieving collections, 18.5
    using to retrieve object metadata, 18.3
  missing data columns
    SQL*Loader, 8.13.6
  moving databases between platforms, 19.13
  multibyte character sets
    blanks with SQL*Loader, 9.5.1
    SQL*Loader, 8.10.1
  multiple-column indexes
    SQL*Loader, 11.5.2.3
  multiple-CPU systems
    optimizing direct path loads, 11.6
  multiple-table load
    generating unique sequence numbers using SQL*Loader, 9.13.7
    SQL*Loader control file specification, 8.15
  multithreading
    on multiple-CPU systems, 11.6
  MULTITHREADING parameter
    SQL*Loader command line, 7.2.15

## N

  named pipes
    external table loads, 6.9.3
  native datatypes
    conflicting length specifications
      SQL*Loader, 9.4.2.9
  nested column objects
    loading, 10.1.3
  nested tables
    exporting, 19.27.4.9
      consistency and, 19.9.3
    importing, 19.28.5.3
  NETWORK_LINK parameter
    Data Pump Export utility, 2.4.18
    Data Pump Import utility, 3.4.15
  networks
    Export and Import, 19.16
  NLS_LANG environment variable, 19.17.2
    with Export and Import, 19.17.3
  NOLOGFILE parameter
    Data Pump Export utility, 2.4.19
    Data Pump Import utility, 3.4.16
  nonrecoverable error messages
    Export, 19.14.3
    Import, 19.14.3
  nonscalar datatypes, 10.1.5
  NOT NULL constraint
    load method, 11.3.8
  null data
    missing columns at end of record during load, 8.13.6
    unspecified columns and SQL*Loader, 9.3
  NULL values
    objects, 10.1.5
  NULLIF clause
    SQL*Loader, 9.5, 9.9
  NULLIF...BLANKS clause
    SQL*Loader, 9.5.1
  nulls
    atomic, 10.1.5.2
    attribute, 10.1.5.1
  NUMBER datatype
    SQL*Loader, 9.4.3, 9.4.4
  numeric EXTERNAL datatypes
    delimited form and SQL*Loader, 9.4.5
    determining length, 9.4.6
    SQL*Loader, 9.4.2.5

## O

  object identifiers, 10.2
    importing, 19.28.5.1
  object names
    SQL*Loader, 8.3
  object support, 6.11
  object tables
    loading, 10.2, 10.2
    with a subtype
      loading, 10.2.1
  object type definitions
    exporting, 19.27.4.8
  OBJECT_CONSISTENT parameter
    Export utility, 19.9.16
  objects, 6.10
    considerations for importing, 19.28.5
    creation errors, 19.28.1.2.1
    ignoring existing objects during import, 19.10.14
    import creation errors, 19.10.14
    loading nested column objects, 10.1.3
    NULL values, 10.1.5
    stream record format, 10.1.1
    variable record format, 10.1.2
  offline locally managed tablespaces
    exporting, 19.27.4.4
  OID
    See object identifiers
  online help
    Export and Import, 19.3.5
  operating systems
    moving data to different systems using SQL*Loader, 9.7
  OPTIMAL storage parameter
    used with Export/Import, 19.26.1
  optimizer statistics, 19.28.3
  optimizing
    direct path loads, 11.5
    SQL*Loader input file processing, 8.7
  OPTIONALLY ENCLOSED BY clause
    SQL*Loader, 9.10.2.2
  OPTIONS parameter
    for parallel loads, 8.13.3
    SQL*Loader utility, 8.2.1
  Oracle Advanced Queuing
    See Advanced Queuing
  Oracle Data Pump
    direct path loads
      restrictions, 1.3.1
    direct path unload, 1.3.1
    external tables access driver, 1.3.2
    features requiring privileges, 1.2
    master table, 1.5.2
    tuning performance, 4.2
  Oracle Data Pump API, 5
    client interface, 5.1
    job states, 5.1.1
    monitoring job progress, 1.6.1
  ORACLE_DATAPUMP access driver
    effect of SQL ENCRYPT clause on, 14.1.4
    reserved words, 14, 14.5
  ORACLE_LOADER access driver
    reserved words, 13, 13.5
  OWNER parameter
    Export utility, 19.9.17

## P

  padding of literal strings
    SQL*Loader, 9.5.2
  parallel loads, 11.9
    restrictions on direct path, 11.9.4
  PARALLEL parameter
    Data Pump Export utility
      command-line interface, 2.4.20
      interactive-command mode, 2.6.7
    Data Pump Import utility
      command-line mode, 3.4.17
      interactive-command mode, 3.6.5
    SQL*Loader command line, 7.2.16
  parameter files
    Export, 19.9.18
    Export and Import
      comments in, 19.3.3
      maximum size, 19.3.3
    Import, 19.10.18
    SQL*Loader, 7.2.17
  PARFILE parameter
    Data Pump Export utility, 2.4.21
    Data Pump Import utility, 3.4.18
    Export command line, 19.9.18
    Import command line, 19.10.18
    SQL*Loader command line, 7.2.17
  partitioned loads
    concurrent conventional path loads, 11.8.4
    SQL*Loader, 11.8.4
  partitioned tables
    export consistency and, 19.9.3
    exporting, 19.8.1
    importing, 19.8.2.1, 19.12.1
    loading, 11.3.2
  partitioning a database migration, 19.29
    advantages of, 19.29
    disadvantages of, 19.29
    procedure during export, 19.29.3
  partition-level Export, 19.8.1
    example session, 19.11.4
  partition-level Import, 19.8.2
    specifying, 19.9.26
  pattern matching
    table names during import, 19.10.29
  performance
    improving when using integrity constraints, 11.8.4
    issues when using external tables, 12.5
    optimizing for direct path loads, 11.5
    optimizing reading of SQL*Loader data files, 8.7
    tuning original Import, 19.28.4
  performance tuning
    Oracle Data Pump, 4.2
  PIECED parameter
    SQL*Loader, 11.4.7.1
  POSITION parameter
    using with data containing tabs, 9.2.1
    with multiple SQL*Loader INTO TABLE clauses, 8.15.2.1, 9.2, 9.2.2
  predetermined size fields
    SQL*Loader, 9.10.2.1
  predetermined size LOBs, 10.4.2.2.2
  prerequisites
    SQL*Loader, 11.1
  PRESERVE parameter, 8.12.2
  preserving
    whitespace, 9.11
  PRIMARY KEY constraints
    effect on direct path load, 11.9.8
  primary key OIDs
    example, 10.2
  primary key REF columns, 10.3.2, 10.3.2
  privileges
    EXEMPT ACCESS POLICY
      effect on direct path export, 19.27.2.1
    required for Export and Import, 19.2.1
    required for SQL*Loader, 11.1

## Q

  QUERY parameter
    Data Pump Export utility, 2.4.22
    Data Pump Import utility, 3.4.19
    Export utility, 19.9.19
      restrictions, 19.9.19.1
  quotation marks
    escape characters and, 8.3.3.2
    filenames and, 8.3.3.1
    SQL strings and, 8.3.2
    table names and, 19.9.26.1, 19.10.29.1
    usage in Data Pump Export, 2.4
    usage in Data Pump Import, 3.4
    use with database object names, 8.3.1

## R

  RAW datatype
    SQL*Loader, 9.4.2.6
  read-consistent export, 19.9.3
  read-only tablespaces
    Import, 19.20
  READSIZE parameter
    SQL*Loader command line, 7.2.18
      effect on LOBs, 7.2.18
      maximum size, 7.2.18
  RECNUM parameter
    use with SQL*Loader SKIP parameter, 9.13.4
  RECORDLENGTH parameter
    Export utility, 19.9.20
    Import utility, 19.10.19
  records
    consolidating into a single logical record
      SQL*Loader, 8.12
    discarded by SQL*Loader, 6.7, 8.9
    DISCARDMAX command-line parameter, 7.2.9
    distinguishing different formats for SQL*Loader, 8.15.2
    extracting multiple logical records using SQL*Loader, 8.15
    fixed format, 6.4.1
    missing data columns during load, 8.13.6
    rejected by SQL*Loader, 6.7, 6.7.1.1, 6.7.1.2, 8.8
    setting column to record number with SQL*Loader, 9.13.4
    specifying how to load, 7.2.13
    specifying length for export, 19.9.20
    specifying length for import, 19.10.19
    stream record format, 6.4.3
  recovery
    direct path load
      SQL*Loader, 11.4.6
    replacing rows, 8.13.2.2
  redo log file
    LogMiner utility
      versions supported, 17.13.3
  redo log files
    analyzing, 17
    requirements for LogMiner utility, 17.2.1.2
    specifying for the LogMiner utility, 17.3.2
  redo logs
    direct path load, 11.4.6.1
    instance and media recovery
      SQL*Loader, 11.4.6.1
    minimizing use during direct path loads, 11.5.4
    saving space
      direct path load, 11.5.4.2
  REF columns, 10.3
    loading, 10.3
    primary key, 10.3.2
    system-generated, 10.3.1
  REF data
    importing, 19.28.5.4
  referential integrity constraints
    disabling for import, 19.6.2
    SQL*Loader, 11.8
  refresh error
    snapshots
      Import, 19.18.1
  reject files
    specifying for SQL*Loader, 8.8
  rejected records
    SQL*Loader, 6.7, 8.8
  relative field positioning
    where a field starts and SQL*Loader, 9.10.3
    with multiple SQL*Loader INTO TABLE clauses, 8.15.1.1
  REMAP_DATAFILE parameter
    Data Pump Import utility, 3.4.20
  REMAP_SCHEMA parameter
    Data Pump Import utility, 3.4.21
  REMAP_TABLESPACE parameter
    Data Pump Import utility, 3.4.22
  remote operation
    Export/Import, 19.16.2
  REPLACE table
    replacing a table using SQL*Loader, 8.13.2.2.2
  reserved words
    external tables, 12.6
    ORACLE_DATAPUMP access driver, 14, 14.5
    ORACLE_LOADER access driver, 13, 13.5
    SQL*Loader, 6.3
  resource consumption
    controlling in Data Pump Export utility, 4.2.1
    controlling in Data Pump Import utility, 4.2.1
  resource errors
    Import, 19.28.1.2.3
  RESOURCE role, 19.4
  restrictions
    importing into another user's schema, 19.4.2
    table names in Export parameter file, 19.9.26.1
    table names in Import parameter file, 19.10.29.1
  RESUMABLE parameter
    Export utility, 19.9.21
    Import utility, 19.10.20
    SQL*Loader utility, 7.2.19
  resumable space allocation
    enabling and disabling, 7.2.19, 19.9.21, 19.10.20
  RESUMABLE_NAME parameter
    Export utility, 19.9.22
    Import utility, 19.10.21
    SQL*Loader utility, 7.2.20
  RESUMABLE_TIMEOUT parameter
    Export utility, 19.9.23
    Import utility, 19.10.22
    SQL*Loader utility, 7.2.21
  retrieving object metadata
    using Metadata API, 18.3
  REUSE_DATAFILES parameter
    Data Pump Import utility, 3.4.23
  roles
    EXP_FULL_DATABASE, 19.2.3
    RESOURCE, 19.4
  rollback segments
    effects of CONSISTENT Export parameter, 19.9.3
  row errors
    Import, 19.28.1.1.1
  ROWID columns
    loading with SQL*Loader, 11.1.1
  rows
    choosing which to load using SQL*Loader, 8.13.4
    exporting, 19.9.24
    specifying for import, 19.10.23
    specifying number to insert before save
      SQL*Loader, 11.4.5.1
    updates to existing rows with SQL*Loader, 8.13.2.2.3
  ROWS parameter
    Export utility, 19.9.24
    Import utility, 19.10.23
    performance issues
      SQL*Loader, 11.5.3
    SQL*Loader command line, 7.2.22
    using to specify when data saves occur, 11.4.5.1
  running
    ASMCMD, 20.3

## S

  SAMPLE parameter
    Data Pump Export utility, 2.4.23
  schema mode export
    Data Pump Export utility, 2.2.2.2
  schemas
    specifying for Export, 19.9.26
  SCHEMAS parameter
    Data Pump Export utility, 2.4.24
    Data Pump Import utility, 3.4.24
  scientific notation for FLOAT EXTERNAL, 9.4.2.5
  script files
    running before Export and Import, 19.2.1
  SDFs
    See secondary datafiles
  secondary datafiles, 6.5, 10.6.2
  security considerations
    direct path export, 19.27.2.1
  segments
    temporary
      FILE parameter in SQL*Loader, 11.9.6.1
  sequence numb, 9.13.6
  sequence numbers
    cached, 19.27.4.1
    exporting, 19.27.4.1
    for multiple tables and SQL*Loader, 9.13.7
    generated by SQL*Loader SEQUENCE clause, 9.13.6
    generated, not read and SQL*Loader, 9.3
  short records with missing data
    SQL*Loader, 8.13.6
  SHORTINT datatype
    C language, 9.4.1.2
  SHOW parameter
    Import utility, 19.10.24
  SILENT parameter
    SQL*Loader command line, 7.2.23
  single-byte character sets
    Export and Import, 19.17.3
  SINGLEROW parameter, 8.14.2, 11.7
  single-table loads
    continuing, 8.11.5
  SKIP parameter
    effect on SQL*Loader RECNUM specification, 9.13.4
    SQL*Loader command line, 7.2.24, 7.2.24
  SKIP_INDEX_MAINTENANCE parameter
    SQL*Loader command line, 7.2.25, 11.7
  SKIP_UNUSABLE_INDEXES parameter
    Import utility, 19.10.25
    SQL*Loader command line, 7.2.26, 11.7
  SKIP_USABLE_INDEXES parameter
    Data Pump Import utility, 3.4.25
  skipping index maintenance, 7.2.25, 11.7
  skipping unusable indexes, 7.2.26, 11.7
  SMALLINT datatype, 9.4.1.2
  snapshot log
    Import, 19.18.1
  snapshots, 19.18.2
    importing, 19.18
    master table
      Import, 19.18.1
    restoring dropped
      Import, 19.18.2.1
  SORTED INDEXES clause
    direct path loads, 8.14.1
    SQL*Loader, 11.5.2.1
  sorting
    multiple-column indexes
      SQL*Loader, 11.5.2.3
    optimum sort order
      SQL*Loader, 11.5.2.4
    presorting in direct path load, 11.5.2
    SORTED INDEXES clause
      SQL*Loader, 11.5.2.1
  SQL operators
    applying to fields, 9.12
  SQL strings
    applying SQL operators to fields, 9.12
    quotation marks and, 8.3.2
  SQL*Loader
    appending rows to tables, 8.13.2.2.1
    BAD command-line parameter, 7.2.1
    bad file, 7.2.1
    BADFILE parameter, 8.8
    bind arrays and performance, 8.16.2
    BINDSIZE command-line parameter, 7.2.2, 8.16.3
    choosing which rows to load, 8.13.4
    COLUMNARRAYROWS command-line parameter, 7.2.3
    command-line parameters, 7.1
    continuing single-table loads, 8.11.5
    CONTROL command-line parameter, 7.2.4
    conventional path loads, 6.9.1, 11.2
    DATA command-line parameter, 7.2.5
    data conversion, 6.6
    data definition language
      syntax diagrams, A
    datatype specifications, 6.6
    DATE_CACHE command-line parameter, 7.2.6
    determining default schema, 8.13.1.1
    DIRECT command-line parameter, 11.4.2
    direct path method, 6.9.2
      using date cache feature to improve performance, 11.5.6
    DISCARD command-line parameter, 7.2.8
    discarded records, 6.7
    DISCARDFILE parameter, 8.9.1
    DISCARDMAX command-line parameter, 7.2.9
    DISCARDMAX parameter, 8.9.6
    DISCARDS parameter, 8.9.6
    errors caused by tabs, 9.2.1
    ERRORS command-line parameter, 7.2.10
    exclusive access, 11.8.3
    external table loads, 6.9.3
    EXTERNAL_TABLE parameter, 7.2.11
    FILE command-line parameter, 7.2.12
    filenames, 8.3
    globalization technology, 8.10
    index options, 8.14
    inserting rows into tables, 8.13.2.1.1
    INTO TABLE statement, 8.13
    LOAD command-line parameter, 7.2.13
    load methods, 11.1
    loading column objects, 10.1
    loading data across different platforms, 9.7
    loading data contained in the control file, 9.13.1
    loading object tables, 10.2
    LOG command-line parameter, 7.2.14
    log files, 6.8
    methods of loading data, 6.9
    multiple INTO TABLE statements, 8.15
    MULTITHREADING command-line parameter, 7.2.15
    object names, 8.3
    parallel data loading, 11.9, 11.9.3, 11.10
    PARFILE command-line parameter, 7.2.17
    READSIZE command-line parameter, 7.2.18
      maximum size, 7.2.18
    rejected records, 6.7
    replacing rows in tables, 8.13.2.2.2
    required privileges, 11.1
    RESUMABLE parameter, 7.2.19
    RESUMABLE_NAME parameter, 7.2.20
    RESUMABLE_TIMEOUT parameter, 7.2.21
    ROWS command-line parameter, 7.2.22
    SILENT command-line parameter, 7.2.23
    SINGLEROW parameter, 8.14.2
    SKIP_INDEX_MAINTENANCE command-line parameter, 7.2.25
    SKIP_UNUSABLE_INDEXES command-line parameter, 7.2.26
    SORTED INDEXES during direct path loads, 8.14.1
    specifying columns, 9.3
    specifying datafiles, 8.5
    specifying field conditions, 9.5
    specifying fields, 9.3
    specifying more than one datafile, 8.5.2
    STREAMSIZE command-line parameter, 7.2.27
    suppressing messages, 7.2.23
    updating rows, 8.13.2.2.3
    USERID command-line parameter, 7.2.28
  SQLFILE parameter
    Data Pump Import utility, 3.4.26
  START_JOB parameter
    Data Pump Export utility
      interactive-command mode, 2.6.8
    Data Pump Import utility
      interactive-command mode, 3.6.6
  starting
    LogMiner utility, 17.4
  statistics
    analyzer, 19.28.3
    database optimizer
      specifying for Export, 19.9.25
    optimizer, 19.28.3
    specifying for Import, 19.10.26
  STATISTICS parameter
    Export utility, 19.9.25
    Import utility, 19.10.26
  STATUS parameter
    Data Pump Export utility, 2.4.25
      interactive-command mode, 2.6.9
    Data Pump Import utility, 3.4.27
      interactive-command mode, 3.6.7
  STOP_JOB parameter
    Data Pump Export utility
      interactive-command mode, 2.6.10
    Data Pump Import utility
      interactive-command mode, 3.6.8
  STORAGE parameter, 11.9.6.1.2
  storage parameters
    estimating export requirements, 19.2.2
    OPTIMAL parameter, 19.26.1
    overriding
      Import, 19.26.3
    preallocating
      direct path load, 11.5.1
    temporary for a direct path load, 11.4.3.2
    using with Export/Import, 19.26
  stored functions
    importing, 19.28.5.7
      effect of COMPILE parameter, 19.28.5.7
  stored package, 19.28.5.7
  stored packages
    importing, 19.28.5.7
  stored procedures
    direct path load, 11.8.2.6
    importing, 19.28.5.7
      effect of COMPILE parameter, 19.28.5.7
  stream buffer
    specifying size for direct path, 11.5.5
  stream record format, 6.4.3
    loading column objects in, 10.1.1
  Streams environment in Data Pump
    setting buffer cache size, 4.3.1
  STREAMS_CONFIGURATION parameter
    Data Pump Import utility, 3.4.28
    Import utility, 19.10.27
  STREAMS_INSTANTIATION parameter
    Import utility, 19.10.28
  STREAMSIZE parameter
    SQL*Loader command line, 7.2.27
  string comparisons
    SQL*Loader, 9.5.2
  subpartitioned tables
    loading, 11.3.2
  subtypes
    loading multiple, 8.15.3
  supplemental logging
    LogMiner utility, 17.9
      database-level identification keys, 17.9.1.2
      log groups, 17.9
      table-level, 17.9.3
      table-level identification keys, 17.9.3.1
      table-level log groups, 17.9.3.2, 17.9.3.2
    See also LogMiner utility
  synonyms
    direct path load, 11.3.10
    exporting, 19.27.4.11
  syntax diagrams
    Data Pump Export, 2.8
    Data Pump Import, 3.8
    SQL*Loader, A
    symbols used in BNF variant, B
  SYSDATE parameter
    SQL*Loader, 9.13.5
  system objects
    importing, 19.4.3
  system triggers
    effect on import, 19.7
    testing, 19.7
  system-generated OID REF columns, 10.3.1

## T

  table names
    preserving case sensitivity, 19.9.26.1
  TABLE_EXISTS_ACTION parameter
    Data Pump Import utility, 3.4.29
  table-level Export, 19.8.1
  table-level Import, 19.8.2
  table-mode Export
    Data Pump Export utility, 2.2.2.3
    specifying, 19.9.26
  table-mode Import
    examples, 19.12.1
  tables
    Advanced Queuing
      exporting, 19.27.4.10
      importing, 19.28.5.10
    appending rows with SQL*Loader, 8.13.2.2.1
    defining before Import, 19.6.1
    definitions
      creating before Import, 19.6.1
    exclusive access during direct path loads
      SQL*Loader, 11.8.3
    external, 12
    importing, 19.10.29
    insert triggers
      direct path load in SQL*Loader, 11.8.2
    inserting rows using SQL*Loader, 8.13.2.1.1
    loading data into more than one table using SQL*Loader, 8.15
    loading object tables, 10.2
    maintaining consistency during Export, 19.9.3
    manually ordering for Import, 19.6.3
    master table
      Import, 19.18.1
    name restrictions
      Export, 19.9.26.1
      Import, 19.10.29, 19.10.29.1
    nested
      exporting, 19.27.4.9
      importing, 19.28.5.3
    objects
      order of import, 19.5
    partitioned, 19.8.1
    replacing rows using SQL*Loader, 8.13.2.2.2
    specifying for export, 19.9.26
    specifying table-mode Export, 19.9.26
    SQL*Loader method for individual tables, 8.13.2
    truncating
      SQL*Loader, 8.13.2.2.4
    updating existing rows using SQL*Loader, 8.13.2.2.3
    See also external tables
  TABLES parameter
    Data Pump Export utility, 2.4.26
    Data Pump Import utility, 3.4.30
    Export utility, 19.9.26
    Import utility, 19.10.29
  tablespace mode Export
    Data Pump Export utility, 2.2.2.4
  tablespaces
    dropping during import, 19.21
    exporting a set of, 19.19
    metadata
      transporting, 19.10.33
    read-only
      Import, 19.20
    reorganizing
      Import, 19.22
  TABLESPACES parameter
    Data Pump Export utility, 2.4.27
    Data Pump Import utility, 3.4.31
    Export utility, 19.9.27
    Import utility, 19.10.30
  tabs
    loading datafiles containing tabs, 9.2.1
    trimming, 9.10
    whitespace, 9.10
  temporary segments, 11.9.6.1
    FILE parameter
      SQL*Loader, 11.9.6.1
  temporary storage in a direct path load, 11.4.3.2
  TERMINATED BY clause
    WHITESPACE
      SQL*Loader, 9.4.5.1
    with OPTIONALLY ENCLOSED BY, 9.10.2.2
  terminated fields
    specified with a delimiter, 9.10.2.2
    specified with delimiters and SQL*Loader, 9.4.5.1
  time
    SQL*Loader datatypes for, 9.4.2.2
  TOID_NOVALIDATE parameter
    Import utility, 19.10.31
  TOUSER parameter
    Import utility, 19.10.32
  trailing blanks
    loading with delimiters, 9.4.5.6
  TRAILING NULLCOLS parameter
    SQL*Loader utility, 8.1, 8.13.6.1
  trailing whitespace
    trimming, 9.10.5
  TRANSFORM parameter
    Data Pump Import utility, 3.4.32
  transparent data encryption
    as handled by Data Pump Export, 2.4.6
    as handled by Data Pump Import, 3.4.5
  TRANSPORT_DATAFILES parameter
    Data Pump Import utility, 3.4.33
  TRANSPORT_FULL_CHECK parameter
    Data Pump Export utility, 2.4.28
    Data Pump Import utility, 3.4.34
  TRANSPORT_TABLESPACE parameter
    Export utility, 19.9.28
    Import utility, 19.10.33
  TRANSPORT_TABLESPACES parameter
    Data Pump Export utility, 2.4.29
    Data Pump Import utility, 3.4.35
  transportable tablespaces, 19.19
  transportable-tablespace mode Export
    Data Pump Export utility, 2.2.2.5
  triggers
    database insert, 11.8.2
    logon
      effect in SQL*Loader, 8.13.1.1
    permanently disabled, 11.8.3
    replacing with integrity constraints, 11.8.2.1
    system
      testing, 19.7
    update
      SQL*Loader, 11.8.2.4
  TRIGGERS parameter
    Export utility, 19.9.29
  trimming
    summary, 9.10
    trailing whitespace
      SQL*Loader, 9.10.5
  TTS_FULL_CHECK parameter
    Export utility, 19.9.30
  TTS_OWNERS parameter
    Import utility, 19.10.34

## U

  undo tablespace
    consumption by Data Pump, 1.9
  UNIQUE KEY constraints
    effect on direct path load, 11.9.8
  unique values
    generating with SQL*Loader, 9.13.6
  unloading entire database
    Data Pump Export utility, 2.2.2.1
  UNRECOVERABLE clause
    SQL*Loader, 11.5.4.2
  unsorted data
    direct path load
      SQL*Loader, 11.5.2.2
  updating
    rows in a table
      SQL*Loader, 8.13.2.2.3
  user mode export
    specifying, 19.9.17
  USER_SEGMENTS view
    Export and, 19.2.2
  user-defined constructors, 10.1.6
    loading column objects with, 10.1.6
  USERID parameter
    Export utility, 19.9.31
    Import utility, 19.10.35
    SQL*Loader command line, 7.2.28

## V

  V$DATABASE view, 17.10
  V$LOGMNR_CONTENTS view, 17.5.1
    formatting information returned to, 17.6
    impact of querying, 17.5.1
    information within, 17.5
    limiting information returned to, 17.6
    LogMiner utility, 17.2.2
    requirements for querying, 17.4, 17.5.1
  V$LOGMNR_DICTIONARY view, 17.10
  V$LOGMNR_LOGS view, 17.3.2, 17.10
    querying, 17.10.1
  V$LOGMNR_PARAMETERS view, 17.9.6, 17.10
  V$SESSION_LONGOPS view
    monitoring Data Pump jobs with, 1.6.1
  value datatypes, 9.4, 9.4
  VARCHAR datatype
    SQL*Loader, 9.4.1.9
  VARCHAR2 datatype
    SQL*Loader, 9.4.3
  VARCHARC datatype
    SQL*Loader, 9.4.2.7
  VARGRAPHIC datatype
    SQL*Loader, 9.4.1.8
  variable records, 6.4.2
    format, 10.1.2
  variable-length records
    external tables, 13.2.2
  VARRAW datatype, 9.4.1.10
  VARRAWC datatype, 9.4.2.8
  VARRAY columns
    memory issues when loading, 10.8.1
  VERSION parameter
    Data Pump Export utility, 2.4.30
    Data Pump Import utility, 3.4.36
  VOLSIZE parameter
    Export utility, 19.9.32
    Import utility, 19.10.36

## W

  warning messages
    Export, 19.14.2
    Import, 19.14.2
  WHEN clause
    SQL*Loader, 8.13.4, 9.5
    SQL*Loader discards resulting from, 8.9.4
  whitespace
    included in a field, 9.10.4
    leading, 9.10.1
    preserving, 9.11
    terminating a field, 9.4.5, 9.10.4.1
    trimming, 9.10

## X

  XML columns
    loading, 10.4
    treatment by SQL*Loader, 10.4
  XML type tables
    identifying in SQL*Loader, 8.4
  XMLTYPE clause
    in SQL*Loader control file, 8.4

## Z

  ZONED datatype, 9.4.1.6
    EXTERNAL format
      SQL*Loader, 9.4.2.5